Checkbook EFT Transaction Batch (CM20203)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM20203

Display Name: Checkbook EFT Transaction Batch
Physical Name: CM20203
Technical Name: cmTransactionEFTBatch

Group Display Name: CM Transaction
Group Technical Name: CM Transaction

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Checkbook EFT Transaction Batch'].CHEKBKID AS 'Checkbook EFT Transaction Batch-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM CM20203 AS ['Checkbook EFT Transaction Batch'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Checkbook EFT Transaction Batch'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2	BCHSOURC	Batch Source	String	STR15	15
3	BACHNUMB	Batch Number	String	STR15_LBAU	15
4	POSTEDDT	Posted Date	Date	DATE	6
5	NUMOFTRX	Number Of TRX	Long Integer	LI6_U0	6
6	BCHTOTAL	Batch Total	Currency	DLR19_RBS0_STR$	19
7	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Checkbook EFT Transaction Batch'].USERID AS 'Checkbook EFT Transaction Batch-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM CM20203 AS ['Checkbook EFT Transaction Batch'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Checkbook EFT Transaction Batch'].USERID = ['Users Master'].USERID
8	EFTGenerationTimestamp	EFT Generation Timestamp	String	STR30	30
9	EFT_Status	EFT Status	Integer	EFT_Status_DDL	0
10	SERIES	Series	Integer	DDL_Series	0